# name : import from xlsx using file formats and filenmae
# key : import.xlsx.import
# contributor: Shuguang Sun
# --
filename ${1:infname} '${2:fname}';
%let __omsglevel__=%sysfunc(getoption(msglevel));
options msglevel=i;
proc import out=${3:dout} datafile=$1 dbms=xlsx replace;
  sheet="${4:sheetname}";
  range= name | "sheet$ul:lr";
  getnames=yes;
  datarow=2;
run;
options msglevel=__omsglevel__;
filename $1 clear;